Minimizing roundtrip response time in distributed databases with vertical fragmentation
نویسندگان
چکیده
Rodolfo A. Pazos R.1, Graciela Vázquez A.2José A. Martı́nez F.3Joaquı́n Pérez O.4 Juan J. Gonzalez B.5 1 Instituto Tecnológico de Cd. Madero, Mexico r pazos [email protected] 2 ESIME, Instituto Politécnico Nacional, Mexico [email protected] 3 Instituto Tecnológico de Cd. Madero, Mexico [email protected] 4 Centro Nacional de Investigación y Desarrollo Tecnológico, Mexico [email protected] 5 Instituto Tecnológico de Cd. Madero, Mexico [email protected]
منابع مشابه
Applying Vertical Fragmentation Techniques in Logical Design of Multidimensional Databases
In the context of multidimensional databases implemented on relational DBMSs through star schemes, the most effective technique to enhance performances consists of materializing redundant aggregates called views. In this paper we investigate the problem of vertical fragmentation of views aimed at minimizing the workload response time. Each view includes several measures which not necessarily ar...
متن کاملA Mixed Fragmentation Methodology for Initial Distributed Database Design
We deene mixed fragmentation as a process of simultaneously applying the horizontal and vertical fragmentation on a relation. It can be achieved in one of two ways: by performing horizontal fragmentation followed by vertical fragmentation or by performing vertical fragmentation followed by horizontal fragmentation. The need for mixed fragmentation arises in distributed databases because databas...
متن کاملVertical Fragmentation of Views in Relational Data Warehouses
Within the framework of the data warehouse design methodology we are developing, in this paper we investigate the problem of vertical fragmentation of relational views aimed at minimizing the global query response time. Each view includes several measures which, within the workload, are seldom requested together; thus, the system performance may be increased by partitioning the views to be mate...
متن کاملExamining the Performance of Vertical Fragmentation using FP-MAX Algorithm
Today’s business Environment has an increasing need for consistent, scalable, reliable and accessible information which grows steadily.The purpose of this work is to analyse the performance of Vertical Fragmentation on large as well as small database such as educational database, data warehouses, medical databases. Vertical Fragmentation has an important impact in improving the performance of m...
متن کاملMaterialization of fragmented views in multidimensional databases
The most effective technique to enhance performances of multidimensional databases consists in materializing redundant aggregates called views. In the classical approach to materialization, each view includes all and only the measures of the cube it aggregates. In this paper we investigate the benefits of materializing views in vertical fragments, aimed at minimizing the workload response time....
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
- J. Computational Applied Mathematics
دوره 259 شماره
صفحات -
تاریخ انتشار 2014